-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesSite`
--

CREATE TABLE IF NOT EXISTS `CodesSite` (
  `SiteCode` text NOT NULL,
  `SiteCtry` text NOT NULL,
  `SiteName` text NOT NULL,
  `SiteNameFull` text NOT NULL,
  `SiteElev` text NOT NULL,
  `SiteLat` text NOT NULL,
  `SiteLong` text NOT NULL,
  `SiteUseDates` text NOT NULL,
  `URL` text NOT NULL,
  `PondName` text NOT NULL,
  `PondArea` text NOT NULL,
  `Notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesSite`
--

INSERT INTO `CodesSite` (`SiteCode`, `SiteCtry`, `SiteName`, `SiteNameFull`, `SiteElev`, `SiteLat`, `SiteLong`, `SiteUseDates`, `URL`, `PondName`, `PondArea`, `Notes`) VALUES
('A', 'Panama', 'Aguadulce', 'Aguadulce Brackishwater Experiment Station, Aguadulce, Cocle, Panama', '0', '8.15 N', '80.29 W', '1983 - 1987', 'http://www.orst.edu/Dept/crsp/who_we_are/pan/pan_sites.html#anchor8949491', '1-70, ESERV, O SHR, R', '500-650, 2000, 10000', ''),
('B', 'Panama', 'Gualaca', 'Gualaca Freshwater Aquaculture Research Station, Gualaca, Panama', '100', '8.31 N', '82.19 W', '1983 - 1987', 'http://www.orst.edu/Dept/crsp/who_we_are/pan/pan_sites.html#anchor9248392', '1-18', '800', ''),
('C', 'Thailand', 'Ayutthaya', 'Ayutthaya Freshwater Fisheries Station, Ayutthaya, Thailand', '5', '14.75 N', '100.50 E', '1984 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/thai/thai_sites.html#anchor4488573', '1-16, A01-A03, B01-B03, C01-C03, D01-D03', '245', ''),
('D', 'Thailand', 'Nong Sua', 'Nong Sua Fish Hatchery, Nong Sua, Thailand (preliminary site for AIT)', '5', '14.11 N', '100.54 E', '1983 - 1984', 'http://www.orst.edu/Dept/crsp/who_we_are/thai/thai_sites.html#anchor4490965', '1-12', '800, 1600, 3200', ''),
('E', 'Indonesia', 'Babakan', 'Babakan Fisheries Station, Bogor, West Java, Indonesia', '220', '6.60 S', '106.70 E', '1983 - 1987', 'http://www.orst.edu/Dept/crsp/who_we_are/ind/Bog.html', 'C01-C09, D05-D07, E01-E04, POOLE, CL.BD, INLET', '200', ''),
('F', 'Honduras', 'El Carao', 'El Carao National Fish Culture Research Center, Comayagua, Honduras', '583', '14.26 N', '87.41 W', '1983 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/hond/hond_sites.html#anchor9387142', 'B01-B12', '1000', ''),
('G', 'Philippines', 'Iloilo', 'Iloilo Brackishwater Aquaculture Center, Iloilo, Philippines', '4', '10.45 N', '122.30 E', '1984 - 1987', 'http://www.orst.edu/Dept/crsp/who_we_are/phil/phil_sites.html#anchor5407358', 'A29-A49, B01-B44', '1000', ''),
('H', 'Rwanda', 'Rwasave', 'Rwasave Fish Culture Station, Butare, Rwanda', '1625', '2.40 S', '29.45 E', '1985 - 1994', 'http://www.orst.edu/Dept/crsp/who_we_are/rwan/rwan_site.html', 'B01-B10, C02-C10, D01-D11', '700', ''),
('I', 'Thailand', 'AIT', 'Asian Institute of Technology (AIT), Klong Luang, Thailand', '5', '14.20 N', '100.35 E', '1987 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/thai/thai_sites.html#anchor4487379', '1-20, H01-H16, I16-I30, J02-J03, K01-K03, SUPPL', '200, 2000', ''),
('J', 'Honduras', 'Choluteca', 'Gulf of Fonseca, Choluteca Region, Honduras', '0', '13.20 N', '87.15 W', '1992 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/hond/hond_sites.html#anchor9388265', 'NONE', '0', ''),
('K', 'Egypt', 'Abbassa', 'Central Laboratory for Aquaculture Research, Abbassa, Egypt', '6', '30.32 N', '31.44 E', '1992 - 1995', 'http://www.orst.edu/Dept/crsp/who_we_are/eg/eg.html', '1-30', '100, 1000, 4200', ''),
('Z4', 'USA', 'U of OK', 'University of Oklahoma, Oklahoma, USA', '', '', '', '1992 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/', '', '', ''),
('M', 'Mexico', 'UJAT', 'Universidad Ju?rez Aut?noma de Tabasco (UJAT), Villahermosa, Mexico', '10', '18.00 N', '92.88 W', '1999 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/', '', '', ''),
('Z1', 'USA', 'AU', 'Auburn University, Alabama, USA', '', '', '', '1983 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/', '', '', ''),
('Z2', 'USA', 'OSU', 'Oregon State University, Corvallis, Oregon, USA', '100', '43.00 N', '90.00 W', '1992 - present', 'http://biosys.bre.orst.edu', 'none', 'none', ''),
('P', 'Philippines', 'FAC', 'Freshwater Aquaculture Center (FAC), Central Luzon State University, Philippines', '30', '15.43 N', '120.54 E', '1992 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/phil/phil_sites.html#anchor5405958', '1-9, 6A-6K, 5H-5K, ALL', '500', ''),
('Z5', 'USA', 'UAPB', 'University of Arkansas at Pine Bluff, Arkansas, USA', '', '', '', '1992 ? present', 'http://pdacrsp.orst.edu/pubs/publications.html#sitedescriptions', '', '', ''),
('R', 'Peru', 'IIAP', 'Instituto de Investigaciones de la Amazonia Peruana (IIAP), Peru', '', '', '', '', 'http://pdacrsp.orst.edu/pubs/peru.pdf', '0', '0', ''),
('S', 'Kenya', 'Sagana', 'Sagana Fish Culture Farm, Sagana, Kenya (Fisheries Department, Ministry of Natural Resources)', '1230', '0.0 deg., 39.72 min. S', '37 deg., 11.12 min. E', '1998 - present', 'http://www.orst.edu/Dept/crsp/who_we_are/ken/kenya.html', 'E01-E09, D01-D08', '800', 'Climate: medium- high elevation equatorial.  Soil type: black cotton (2:1 montmorrilonite).  Source water: Ragathi river, Mount Kenya drainage, no pre-treatment.'),
('U', 'Thailand', 'Huay Luang', 'Huay Luang Fisheries Station, Huay Luang, Thailand', '', '17.5 N', '102.75 E', '1983', 'http://www.orst.edu/Dept/crsp/who_we_are/thai/thai_sites.html#anchor4487379', '0', '0', ''),
('Z3', 'USA', 'U of CA', 'University of California at Davis, California, USA', '', '', '', '1983 ? present', 'http://www.orst.edu/Dept/crsp/who_we_are/', '', '', ''),
('Z', 'Global', 'Global', 'Global/regional studies (includes U.S. universities)', '', '', '', '', 'None', '', '', ''),
('O', 'Honduras', 'Zamorano', 'Escuela Agr&iacute;cola Panamericana El Zamorano, Zamorano, Honduras', '', '', '', '', '', '', '', '');
